<?php

/*
 * Created on Dec 1, 2011
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
$sname = null;
$smac = null;
$slocation = null;

$con = mysql_connect("localhost", "root", "bytewalla5");
if (!$con) {
	die('Could not connect: ' . mysql_error());
}

mysql_select_db("wsn", $con);

if ($_GET["mac"] == null) {
	if ($_POST["action"] == "update") {
		$quer = "UPDATE sunspot SET spotname = '" . $_POST["Sname"] . "', location = '" . $_POST["Slocation"] . "' WHERE spot_mac_addr = '" . $_POST["spot_mac"] . "'";
		$query = mysql_query($quer);
		mysql_close($con);
		header("Location:sunspotlist.php");
	}
} else {

	$result = mysql_query("SELECT * FROM sunspot where spot_mac_addr='" . $_GET["mac"] . "'");
	echo $result;
	while ($row = mysql_fetch_array($result)) {
		$sname = $row['spotname'];
		$smac = $row['spot_mac_addr'];
		$slocation = $row['location'];

	}

mysql_close($con);

}
?>

<!DOCTYPE html>
<html lang="en">
<head>
<title>Sunspot Info</title>
<meta charset="utf-8">
<link rel="stylesheet" href="css/reset.css" type="text/css" media="all">
<link rel="stylesheet" href="css/layout.css" type="text/css" media="all">
<link rel="stylesheet" href="css/style.css" type="text/css" media="all">
<script type="text/javascript" src="js/jquery-1.6.js" ></script>
<script type="text/javascript" src="js/cufon-yui.js"></script>
<script type="text/javascript" src="js/cufon-replace.js"></script>
<script type="text/javascript" src="js/Swis721_Cn_BT_400.font.js"></script>
<script type="text/javascript" src="js/Swis721_Cn_BT_700.font.js"></script>
<script type="text/javascript" src="js/tabs.js"></script>
<!--[if lt IE 9]>
  	<script type="text/javascript" src="js/html5.js"></script>
	<style type="text/css">
		.bg{ behavior: url(js/PIE.htc); }
	</style>
<![endif]-->
<!--[if lt IE 7]>
		<div style=' clear: both; text-align:center; position: relative;'>
			<a href="http://www.microsoft.com/windows/internet-explorer/default.aspx?ocid=ie6_countdown_bannercode"><img src="http://www.theie6countdown.com/images/upgrade.jpg" border="0"  alt="" /></a>
		</div>
<![endif]-->
</head>
<body id="page5">
	<div class="body1">
	<div class="body2">
	<div class="body5">
		<div class="main">
<!-- header -->
			<?php include("wsnheader.html"); ?>
<!-- header end-->
		</div>
	</div>
	</div>
	</div>
	<div class="body3">
		<div class="main">
<!-- content -->
			<article id="content">
				<div class="wrapper">
					<section class="col1">
						<h2 class="under">Sunspot Info</h2>
						<form id="ContactForm" action="sunspot.php" method="post">
						<div>
					
							<div  class="wrapper">
								<span>Name:</span>
								<input type="text" name="Sname" value="<?php echo $sname; ?>" class="input" >
							</div>
							<div  class="wrapper">
								<span>Mac-Addr:</span><?php echo $smac; ?>
								<input type="hidden" name="spot_mac" value="<?php echo $smac; ?>" >
							</div>
							
							<div  class="wrapper">
								<span>Location:</span>
								<input type="text" name="Slocation" value="<?php echo $slocation; ?>" class="input" ><br/><br/>
								<input type="hidden" name="action" value="update" >
								<a href="#" onClick="document.getElementById('ContactForm').submit()">update</a>
								<a href="#" onClick="document.getElementById('ContactForm').reset()">Clear</a>
							</div>
						
						</div>
					</form>
					</section>
					
				</div>

			</article>
		</div>
	</div>
	
<!-- content end -->
<!-- footer -->
			<?php include("footer.html"); ?>
<!-- footer end -->
<script type="text/javascript"> Cufon.now(); </script>
<script>
	$(document).ready(function() {
		tabs.init();
	})
</script>
</body>
</html>